﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;

namespace DataMigration
{
    public class DataRelated
    {
        private const string _connectionString = "Data Source=DREAMZ\\SQLEXPRESS;Initial Catalog=Sikra;Persist Security Info=True;User ID=sa;Password=test";

        private static SqlConnection _connection;

        private SqlConnection Connection 
        {
            get 
            {
                if (null == _connection)
                    _connection = new SqlConnection(_connectionString);
                return _connection;
            }
        }

        public static bool MigratePersonDetails()
        {
            bool status = false;

            string selectPerson = @"SELECT [PersonID], [AddressID], [Title], [FirstName], [LastName], [EntryDate], [CreateDate], [ModifyDate] FROM [dbo].[Persons]";


            return status;
        }
    }
}
